using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using sgsBase;
 
namespace gaClear
{
	[Serializable] public class DbClearingUnresolved :  DbObject
	{
	  public DbClearingUnresolved() : base()
	  {
			Table = "dbo.clearing_unresolved";
		  Database = "gagm_energy";
		  Columns.AddColumn("clear_id", SqlDbType.Int, true, false);
		  Columns.AddColumn("column_name", SqlDbType.VarChar, true, false);
		  Columns.AddColumn("data_table", SqlDbType.VarChar);
		  Columns.AddColumn("data_id_fld", SqlDbType.VarChar);
		  Columns.AddColumn("data_desc_fld", SqlDbType.VarChar);
		  Columns.AddColumn("data_where_clause", SqlDbType.VarChar);
		  Columns.AddColumn("addl_column_name", SqlDbType.VarChar);
		  Columns.AddColumn("addl_data_id_fld", SqlDbType.VarChar);
		  Columns.AddColumn("related_clear_id", SqlDbType.Int);
	  }
  
	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  	  #region Properties
  
      public int ClearId
      {
          get { return Columns.IntAt(0);}
          set { Columns.SetValAt(0, value);}
      }

      public String ColumnName
      {
          get { return Columns.StringAt(1);}
          set { Columns.SetValAt(1, value);}
      }

      public String DataTableU
      {
          get { return Columns.StringAt(2);}
          set { Columns.SetValAt(2, value);}
      }

      public String DataIdFld
      {
          get { return Columns.StringAt(3);}
          set { Columns.SetValAt(3, value);}
      }

      public String DataDescFld
      {
          get { return Columns.StringAt(4);}
          set { Columns.SetValAt(4, value);}
      }

      public String DataWhereClause
      {
          get { return Columns.StringAt(5);}
          set { Columns.SetValAt(5, value);}
      }

      public String AddlColumnName
      {
          get { return Columns.StringAt(6);}
          set { Columns.SetValAt(6, value);}
      }

      public String AddlDataIdFld
      {
          get { return Columns.StringAt(7);}
          set { Columns.SetValAt(7, value);}
      }

      public int RelatedClearId
      {
          get { return Columns.IntAt(8);}
          set { Columns.SetValAt(8, value);}
      }

  
  #endregion
	}
}
